################
#              #
# 设备人员自动添加 #
#              #
#              #
############## #
from pythonDemo.com.xyh.pytools.diff_error_data import my_jdbc as kcjdbc

if __name__ == '__main__':
    device_sql = """
                select 
                    k.id,
                    k.material_number as materialNumber,
                    k.name,
                    k.classify,
                    k.model,
                    k.mfrs,
                    k.scope,
                    k.precision,
                    k.check,
                    k.check_cycle as checkCycle,
                    k.fixture
                from 
                    kc_device_type k
                   """
    data_list = kcjdbc.getKcMesDataList(device_sql)

